package org.jeecg.modules.demo.yhs.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.demo.yhs.POJO.Vip;

import java.sql.Date;
import java.util.List;

@Mapper
public interface VipMapper {

    @Select("select * from vip where time=#{s} and viptype=1")
    List<Vip> findByDate(Date s);

    @Select("select count(*) from vip")
    int findAll();

    @Select("select count(*) from vip where viptype=#{i}")
    int findByType(int i);
}
